capture cd D:\Dropbox\book_welfare\replication\


import delimited data\goodreads_book_works.json, delimiter(comma) clear 

	split v7, parse(": ")
	gen oyear=real(substr(v72,2,4))


	split v6, parse(": ")
	gen bookid=substr(v62,2,.)
	replace bookid=substr(bookid,1,length(bookid)-1)


	keep bookid oyear 
save data\bookid_oyear.dta, replace 